﻿

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[bhp_NemoGroupGet]
	@Id				INT
AS
BEGIN

	SELECT
		t.id as [Id],
		g.Name,
		t.name as SystemName
	FROM
		sTree t
		LEFT JOIN bht_Groups g ON t.id = g.Id
	WHERE
		t.del = 0
		AND t.parent = 0
		AND t.id = @Id
END
GO


